﻿CREATE TABLE [ccc].[Schools] (
    [Id]                   INT           IDENTITY (1, 1) NOT NULL,
    [SchoolType]           SMALLINT      NOT NULL,
    [SchoolName]           VARCHAR (100) NOT NULL,
    [Address1]             VARCHAR (50)  NOT NULL,
    [Address2]             VARCHAR (50)  NULL,
    [Address3]             VARCHAR (50)  NULL,
    [Town]                 VARCHAR (50)  NOT NULL,
    [County]               VARCHAR (50)  NULL,
    [PostCode]             VARCHAR (8)   NOT NULL,
    [SchoolTel]            VARCHAR (50)  NOT NULL,
    [ContactFirstName]     VARCHAR (50)  NOT NULL,
    [ContactLastName]      VARCHAR (50)  NOT NULL,
    [ContactEmail]         VARCHAR (50)  NOT NULL,
    [ContactTel]           VARCHAR (50)  NULL,
    [SecondaryContactName] VARCHAR (50)  NULL,
    [Password]             VARCHAR (50)  NOT NULL,
    [Created]              DATETIME      NOT NULL,
    [LastUpdated]          DATETIME      NOT NULL,
    [ConcurencyId]         TIMESTAMP     NOT NULL
);

